create external table jms_ods.center_indicator_config(
modify_by              string   comment  '更新人'
,modify_time            string   comment  '更新时间'
,status                 string   comment  '状态'
,cgzy_worst             string   comment  '出港转运及时率最差值'
,cgzy_target            string   comment  '出港转运及时率日标值'
,cgzy_challenge         string   comment  '出港转运及时率挑战值'
,cgzy_weights           string   comment  '出港转运及时率权重'
,jgzy_worst             string   comment  '进港转运及时率最差值'
,jgzy_target            string   comment  '进港转运及时率日标值'
,jgzy_challenge         string   comment  '进港转运及时率挑战值'
,jgzy_weights           string   comment  '进港转运及时率权重'
,ksl_worst              string   comment  '客诉率最差值'
,ksl_target             string   comment  '客诉率日标值'
,ksl_challenge          string   comment  '客诉率挑战值'
,ksl_weights            string   comment  '客诉率权重'
,ysl_worst              string   comment  '遗失率最差值'
,ysl_target             string   comment  '遗失率日标值'
,ysl_challenge          string   comment  '遗失率挑战值'
,ysl_weights            string   comment  '遗失率权重'
,psl_worst              string   comment  '破损率最差值'
,psl_target             string   comment  '破损率日标值'
,psl_challenge          string   comment  '破损率挑战值'
,psl_weights            string   comment  '破损率权重'
,zfgx_worst             string   comment  '直发干线装载率最差值'
,zfgx_target            string   comment  '直发干线装载率日标值'
,zfgx_challenge         string   comment  '直发干线装载率挑战值'
,zfgx_weights           string   comment  '直发干线装载率权重'
,czxn_weights           string   comment  '操作效能权重'
,dprl_weights           string   comment  '单票人力成本权重'
,zcbgf_weights          string   comment  '装车不规范权重'
,cjfl_number            string   comment  '车件分离票数'
,cjfl_whole_network     string   comment  '全网占比'
,cjfl_caps              string   comment  '当月异常封顶次数'
,id                     string   comment  '主键'
)comment '转运中心指标权重及目标值设定'
PARTITIONED BY ( `dt` string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_ods.db/external/center_indicator_config'
TBLPROPERTIES (
    'discover.partitions' = 'false',  -- 禁止 hive 自动发现分区
    'parquet.column.index.access' = 'true');

alter table jms_ods.center_indicator_config add columns(
czxn_target string comment "操作效能目標值"
);